³@  -clients.dbfprimarykey/&-#total_payments MY3&-#Payments.projectid MIÌ:8Client ID ˆ6 7 /&-#billing_amount MY1&-#total_hoursMB(8,2)Ì:8Company Name ˆ6 7 :&-!#Time_Card_Hours.projectid MIÌ:8Address ˆ6 7 /&-#total_expenses MYÌ:8City ˆ6 7 P&-7#"time and billing!time_card_expenses".projectid MIÌ:8State/Province ˆ6 7 /&-#total_expenses MYÌ:8Postal Code ˆ6 7 =&-$#Time_Card_Expenses.projectid MIÌ:8Country ˆ6 7 6 workcodeidwork_codesprimarykeyÌ:8Contact First Name ˆ6 7 6 timecardidtime_cardsprimarykeyÌ:8Contact Last Name ˆ6 7 6 timecardidtime_cardsprimarykeyÌ:8Contact Title ˆ6 7 3 projectidprojectsprimarykeyÌ:8Phone Number ˆ6 7 3 projectidprojectsprimarykeyÌ:8Fax Number ˆ6 7 3 projectidprojectsprimarykeyÌ:8Referred By ˆ6 7 ; paymentmetpayment_methodsprimarykeyÌ:8Notes ˆ6 7 /employees.dbfprimarykeyÌ:8Employee ID ˆ6 7 9 expensecodexpense_codesprimarykeyÌ:8Employee Number ˆ6 7 5 employeeidemployeesprimarykeyÌ:8First Name ˆ6 7 5 employeeidemployeesprimarykeyÌ:8Last Name ˆ6 7 1 clientidclientsprimarykeyÌ:8Title ˆ6 7 Ì:8Email Name ˆ6 7 Ì:8Extension ˆ6 7 Ì:8Address ˆ6 7 Ì:8City ˆ6 7 Ì:8State/Province ˆ6 7 <"my company information.dbfprimarykeyÌ:8Postal Code ˆ6 7 Ì:8Country ˆ6 7 Ì:8Home Phone ˆ6 7 Ì:8Work Phone ˆ6 7 Ì:8Billing Rate ˆ6 7 3expense codes.dbfprimarykey0work codes.dbfprimarykeyÌ:8Expense Code ID ˆ6 7 0time cards.dbfprimarykey5time card hours.dbfprimarykeyÌ:8Expense Code ˆ6 7 8time card expenses.dbfprimarykey.projects.dbfprimarykey.payments.dbfprimarykeyÌ:8SetupID ˆ6 7 5payment methods.dbfprimarykeyÌ:8Company Name ˆ6 7 Ì:8Address ˆ6 7 .0$(,PQR /ÿ %d 'ÿÿÿÿ+Paymentsƒ*SELECT DISTINCT Payments.ProjectID, Sum(Payments.PaymentAmount) AS Total_Payments FROM Payments GROUP BY Payments.ProjectID) Ì:8City ˆ6 7 Ì:8State/Province ˆ6 7 Ì:8Work Code ˆ6 7 Ì:8Postal Code ˆ6 7 Ì:8Country ˆ6 7 Ì:8Work Code ID ˆ6 7 Ì:8Phone Number ˆ6 7 Ì:8Fax Number ˆ6 7 Ì:8Date Entered ˆ6 7 Ì:8Default Payment Terms ˆ6 7 Ì:8Default Invoice Description ˆ6 7 Ì:8Employee ID ˆ6 7 Ì:8Payment Method ID ˆ6 7 Ì:8Payment Method ˆ6 7 Ì:8Time Card ID ˆ6 7 Ì:8Credit Card? ˆ6 7 Ì:8Work Code ID ˆ6 7 Ì:8Payment ID ˆ6 7 Ì:8Project ID ˆ6 7 Ì:8Billing Rate ˆ6 7 Ì:8Payment Amount ˆ6 7 Ì:8Payment Date ˆ6 7 Ì:8Billable Hours ˆ6 7 Ì:8Credit Card # ˆ6 7 Ì:8Cardholder Name ˆ6 7 Ì:8Work Description ˆ6 7 Ì:8Card Exp. Date ˆ6 7 Ì:8CC Authoriz. # ˆ6 7 Ì:8Project ID ˆ6 7 Ì:8Payment Method ID ˆ6 7 Ì:8Project ID ˆ6 7 Ì:8Date Worked ˆ6 7 Ì:8Project Name ˆ6 7 Ì:8Project Description ˆ6 7 Ì:8Time Card ID ˆ6 7 Ì:8Client ID ˆ6 7 Ì:8PO Number ˆ6 7 Ì:8Time Card Detail ID ˆ6 7 Ì:8Project Total Billing Estimate ˆ6 7 Ì:8Employee ID ˆ6 7 Ì:8Expense Code ID ˆ6 7 Ì:8Project Begin Date ˆ6 7 Ì:8Project End Date ˆ6 7 c.0$(,PQR /ÿ %d 'ÿÿÿÿ+Time_Card_HoursÐ*SELECT DISTINCT Time_Card_Hours.ProjectID, Sum(Time_Card_Hours.BillableHours) AS Total_Hours, Sum(BillableHours*BillingRate) AS Billing_Amount FROM Time_Card_Hours GROUP BY Time_Card_Hours.ProjectID) Ì:8Time Card Expense ID ˆ6 7 Ì:8Time Card ID ˆ6 7 Ì:8Expense Amount ˆ6 7 Ì:8Expense Date ˆ6 7 Ì:8Project ID ˆ6 7 Ì:8Expense Description ˆ6 7 Î.0$(,PQR /ÿ %d 'ÿÿÿÿ-+"time and billing!time_card_expenses"%*SELECT DISTINCT Time_card_expenses.projectid, SUM(Time_card_expenses.expenseamount) AS total_expenses FROM "time and billing!time_card_expenses" WHERE Time_card_expenses.expensedate >= ?dBeginDate AND Time_card_expenses.expensedate <= ?dEndDate GROUP BY Time_card_expenses.projectid) A.0$(,PQR /ÿ %d 'ÿÿÿÿ+Time_Card_Expenses«*SELECT DISTINCT Time_Card_Expenses.ProjectID, Sum(Time_Card_Expenses.ExpenseAmount) AS Total_Expenses FROM Time_Card_Expenses GROUP BY Time_Card_Expenses.ProjectID)